Comprehensive Centralized-Data Warehouse for Managing Malaria Cases
نویسنده
چکیده
Tanah Bumbu is one of the most endemic areas in Indonesia for patients diagnosed with malaria diseases. Currently, available malaria case data were stored in disparate sources. Hence, it is difficult for the public health department to quickly and easily gather the useful information for determining strategic actions in tackling these cases. The purpose of this research is to build a data warehouse that integrates all malaria cases from disparate sources. This malaria data warehouse is a centralized architecture of galaxy or constellation scheme that consists of three fact tables and 13 dimension tables. SQL Server Integration Services (SSIS) is utilized to build ETL packages that load data from various sources to stages, dimensions, and fact tables in malaria data warehouse. Finally, a timely report can be generated by extracting the salient information located in malaria data warehouse. Keywords—malaria case; centralized data warehouse; galaxy scheme; ETL; timely report
منابع مشابه
Managing Multiple Real and Simulation Business Scenarios by Means of a Multiversion Data Warehouse
This paper addresses problems of the evolution of data warehouse schema and dimensions. In order to handle the evolution, we apply a multiversion data warehouse (MVDW). In this paper we discuss real world cases illustrating a DW evolution and show how to apply the MVDW in order to handle the cases.
متن کاملThe Contribution of IT Governance Solutions to the Implementation of Data Warehouse Practice
Information systems (IS) strategic planners debate what is the most appropriate data warehouse (DW) topology for an organization. The primary question is whether to start DW projects with enterprise-wide data warehouses (EDWs) or with smaller-scale data marts (DMs). This article examines the relationship between modes of IT governance and DW topology to determine whether or not the implementati...
متن کاملTowards Implementing Total Data Quality Management in a Data Warehouse
Poor quality of data in a warehouse adversely impacts the usability of the warehouse and managing data quality in a warehouse is very important. In this article we describe a framework for managing data quality in a data warehouse. This framework is of interest to both academics and practitioners as it offers an intuitive approach for not just managing data quality in a data warehouse but also ...
متن کاملEfficient OLAP Query Processing in Distributed Data Warehouses
The success of Internet applications has led to an explosive growth in the demand for bandwidth from ISPs. Managing an IP network requires collecting and analyzing network data, such as flowlevel traffic statistics. Such analyses can typically be expressed as OLAP queries, e.g., correlated aggregate queries and data cubes. Current day OLAP tools for this task assume the availability of the data...
متن کاملEpidemiology of Malaria in Kashan
ABSTRACT Every year in the city of Kashan various number of cases of malaria has been observed. Determination of the prevalence of the disease and the carriers in this area of the country can play a significant role in employing preventive measure as well as in managing logistic services. Through applying retrospective descriptive methods and based on the statistics reported from the Center o...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2015